﻿/*
Post-Deployment Script Template							
--------------------------------------------------------------------------------------
 This file contains SQL statements that will be appended to the build script.		
 Use SQLCMD syntax to include a file in the post-deployment script.			
 Example:      :r .\myfile.sql								
 Use SQLCMD syntax to reference a variable in the post-deployment script.		
 Example:      :setvar TableName MyTable							
               SELECT * FROM [$(TableName)]					
--------------------------------------------------------------------------------------
*/

INSERT INTO [BPMEngine].[dbo].[ProcessStatuses]
           ([ProcessStatusId]
           ,[ProcessStatusName]
           ,[ProcessStatusDescription])
     VALUES
           (1,
           'Active',
           'Active Process Status'
		   );

INSERT INTO [BPMEngine].[dbo].[ProcessStatuses]
           ([ProcessStatusId]
           ,[ProcessStatusName]
           ,[ProcessStatusDescription])
     VALUES
           (2,
           'Closed',
           'Closed Process Status'
		   );

INSERT INTO [BPMEngine].[dbo].[ProcessStatuses]
           ([ProcessStatusId]
           ,[ProcessStatusName]
           ,[ProcessStatusDescription])
     VALUES
           (3,
           'Cancelled',
           'Cancelled Process Status'
		   );

GO
